Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Previous Next

You can import CSV easily.

Using a COL file.

More details here:

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/topic/com.ibm.designer.domino.main.doc/H_ABOUT_WRITING_A_COL_FILE_FOR_A_TABULAR_TEXT_FILE.html

But as an example.

----
Simon O'Doherty, 555-12345, 1 Main Street
----


Your COL file might look like:

FirstName: UNTIL " ";
LastName: UNTIL ",";
PhoneNumber: UNTIL ",";
AddressLine1: UNTIL "";


After you have your COL File created, you just do a "file->Import", then select Tabular Text and your CSV file. After that select your COL file.
-----

Other then this you can also write LotusScript or Java to read the file and import.

For things like Excel you can use VBA and COM to transfer the data to a Notes Database.


Feedback response number WEBB9H4AQB created by ~Joseph Fezlulitynds on 03/11/2014

Import CSV files (~Tanita Refooko... 30.Jun.10)
. . I have done this before by first br... (~Anita Minaster... 30.Jun.10)
. . . . Me too.. until MS Excel 2007 (~Anita Quetkrot... 30.Jun.10)
. . . . . . Frustrating (~Frank Zekjumis... 2.Sep.11)
. . . . . . . . Frustrated here too (~Zach Nimkigeno... 22.Nov.11)
. . . . . . . . . . Frustrated here also (~Ben Froponetex... 11.Mar.14)
. . . . . . . . . . But it's so easy to do! (~Judy Ektumizen... 12.Mar.14)
. . . . . . . . Absolutely (~Fred Asatumibu... 11.Mar.14)
. . You can import CSV easily. (~Cheryl Opfreet... 11.Mar.14)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS